<?php

$strScreenName = 'ListProduct';
$strQueryName = 'qrySearchProduct';
$strFormName = 'frmSearchProduct';
if($strStyleSheet == TRUE){
	echo "<table class='Normal' border='0' align='left' width='100%' bgcolor='white'>";
}?>


 <tr>
     <td><?=
	 	StartForm($strScreenName, "post", $strQueryName,"","","",$strFormName,"","")?>
         <table  width='450' cellpadding='0' cellspacing='0' border='0' class='Normal' align='center'>
		     <tr align="right">
		         <td align='left' colspan='2'>
		             <h2>Search Product</h2>
		         </td>
		     </tr>

		     <tr>
		         <td align='right' colspan='2'>
		             <input type='image' src='./images<?=SITE_SUFFIX?>/search.gif' alt='search'>
		         </td>
		     </tr>
		
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Product ID :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtID" value = '<?=$txtID?>' size= "6" maxlength="10">
		         </td>
		     </tr>
		
		
			<tr>
		         <td align="right" colspan='1'>
		             <b>Product Name :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtProduct" value = '<?=$txtProduct?>' size= "25" maxlength="100">
		         </td>
		     </tr>
			 
			  <tr>
         <td align='right'>
             <b>Upload Picture :&nbsp;</b>
		 </td>
         <td align="left"><?
             CreateDropDown("cboUploadedPicture", "SELECT * FROM tblYesNo ORDER BY 2", "", $cboUploadedPicture);?>
         </td>
     </tr>
	 
	 

			<tr align="right">
		         <td align="right">
		             <b>Category :&nbsp;</b><br/>
		         </td>
		         <td align="left"><?
		             CreateDropDown("cboCategory", "SELECT * FROM tblCategory ORDER BY 2", "", $cboCategory);?>
		         </td>
		     </tr>
		
		     <tr>
		        <td align="right">
		             <b>Own Product Code :&nbsp;</b>
				</td>
				<td align="left">
		             <input type="text" name="txtOwnProductCode" value = '<?=$txtOwnProductCode?>' size= "25" maxlength="50">
		         </td>
		     </tr>
			<tr>
		        <td align="left" colspan='2'>
				 	<hr/>
				</td>
		     </tr>
			 <tr align="right">
		         <td align="right">
		             <b>Supplier :&nbsp;</b><br/>
		         </td>
		         <td align="left"><?
		             CreateDropDown("cboSupplier", "SELECT * FROM tblSupplier ORDER BY 2", "", $cboSupplier);?>
		         </td>
		     </tr>
			 
			<tr>
		        <td align="right">
				 	<b>Supplier Product ID :&nbsp;</b>
				</td>
				<td align="left">
					<input type="text" name="txtSupplierProductID" value = '<?=$txtSupplierProductID?>' size= "25" maxlength="50">
				</td>
		     </tr>

			<tr>
         		<td align="right" colspan='1'>
             		<b>Bar Code :&nbsp;</b>
         		</td>
         		<td align="left" colspan='1'>
             		<input type="text" name="txtBarcode" value = '<?=$txtBarcode?>' size= "16" maxlength="16">
         		</td>
    		</tr>
		
		     <tr>
		        <td align="left" colspan='2'>
				 	<hr>
				</td>
		     </tr>
			 
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Unit Retail Price (Inc. Vat) :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtUnitPrice" value = '<?=$txtUnitPrice?>' size= "8" maxlength="16">
		         </td>
		     </tr>

		     <tr>
		         <td align="right" colspan='1'>
		             <b>Cost Price&nbsp;(Ex&nbsp;Vat) :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtCostPrice" value = '<?=$txtCostPrice?>' size= "8" maxlength="16">
		         </td>
		     </tr>
		     
			 <tr align="right">
		         <td align="right">
		             <b>Vat Rate :&nbsp;</b><br/>
		         </td>
		         <td align="left"><?
		             CreateDropDown("cboVatRate", "SELECT * FROM tblVatRate ORDER BY 2", "", $cboVatRate);?>
		         </td>
		     </tr>
			 
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Quantity Per Unit :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtQuantityPerUnit" value = '<?=$txtQuantityPerUnit?>' size= "4" maxlength="20">
		         </td>
		     </tr>
			 
			<tr>
		        <td align="left" colspan='2'>
				 	<hr>
				</td>
		     </tr>
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Units In Stock :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtUnitsInStock" value = '<?=$txtUnitsInStock?>' size= "4" maxlength="4">
		         </td>
		     </tr>
		
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Units On Order :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtUnitsOnOrder" value = '<?=$txtUnitsOnOrder?>' size= "4" maxlength="8">
		         </td>
		     </tr>
		
		     <tr>
		         <td align="right" colspan='1'>
		             <b>Reorder Level :&nbsp;</b>
		         </td>
		         <td align="left" colspan='1'>
		             <input type="text" name="txtReorderLevel" value = '<?=$txtReorderLevel?>' size= "3" maxlength="8">
		         </td>
		     </tr>
		<tr>
	         <td align='right'>
	             <b>Discontinued :&nbsp;</b>
			 </td>
	         <td align="left"><?
	             CreateDropDown("cboDiscontinued", "SELECT * FROM tblYesNo ORDER BY 2", "", $cboDiscontinued);?>
	         </td>
	     </tr>

		
		     <!-- <tr>
		         <td align='left' colspan='1'>
		             <b>Upload Picture :&nbsp;</b>
				</td>
		         <td align="left" colspan='1'>
		             <div align="left"><input type="text" name="txtUploadedPicture" value = '<?//=$txtUploadedPicture?>' size= "50" maxlength="50"></div>
		         </td>
		     </tr> -->
		
		     <tr align="right">
		         <td align="right">
		             <b>Promotional Item :&nbsp;</b>
				</td>
		         <td align="left" colspan='1'><?
						CreateDropDown("cboPromotionalItem", "SELECT * FROM tblYesNo ORDER BY 2", "", $cboPromotionalItem);
						/*  <input type="checkbox" name="chkPromotionalItem">*/
						?>

		         </td>
		     </tr>
		     <tr>
		        <td align="left" colspan='2'>
				 	<hr/>
				</td>
		     </tr>
		     <tr>
		         <td align="right"colspan='1'>
		             <b>Date Entered :&nbsp;</b>
		         </td>
		         <td align="left"colspan='1'>
		             <input type="text" name="txtDateAdded" value = '<?=$txtDateAdded?>' size= "10" maxlength="10">
					 &nbsp;-&nbsp;<input type="text" name="txtDateAddedUpperLimit" value = '<?=$txtDateAddedUpperLimit?>' size= "10" maxlength="10">
		         </td>
		     </tr>
		     <tr>
		         <td align="right"colspan='1'>
		             <b>Date Updated :&nbsp;</b>
		         </td>
		         <td align="left"colspan='1'>
		             <input type="text" name="txtDateUpdated" value = '<?=$txtDateUpdated?>' size= "10" maxlength="10">
					 &nbsp;-&nbsp;<input type="text" name="txtDateUpdatedUpperLimit" value = '<?=$txtDateUpdatedUpperLimit?>' size= "10" maxlength="10">
		         </td>
		     </tr>
		     <tr>
		         <td align="right"colspan='1'>
		             <b>Updated By :&nbsp;</b>
		         </td>
		         <td align="left"colspan='1'><?
		         	CreateDropDown('cboUpdatedBy',"SELECT ID, CONCAT(Surname, ',', FirstName) FROM tblStaff ORDER BY Surname")?>
		         </td>
		     </tr>
		     <tr>
		        <td align="left" colspan='2'>
				 	<hr/>
				</td>
		     </tr>
		     <tr>
		         <td align='right' colspan='2'>
		             <input type='image' src='<?php echo "./images".SITE_SUFFIX?>/search.gif' alt='search'>
		         </td>
		     </tr>
         </table><?=
		 "</form>"?>
     </td>
</tr>
<?php
	if($strStyleSheet == TRUE){
   		echo "</table>";
	}
?>
